CREATE TABLE [dbo].[MemorialTributeNotificationMember]
(
[GroupMemberKey] [uniqueidentifier] NOT NULL,
[RelationshipKey] [uniqueidentifier] NULL,
[MemorialTributeNotificationPreferenceCode] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MemorialTributeNotificationMember] ADD CONSTRAINT [PK_MemorialTributeNotificationMember] PRIMARY KEY CLUSTERED ([GroupMemberKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MemorialTributeNotificationMember_MemorialTributeNotificationPreferenceCode] ON [dbo].[MemorialTributeNotificationMember] ([MemorialTributeNotificationPreferenceCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MemorialTributeNotificationMember] ADD CONSTRAINT [FK_MemorialTributeNotificationMember_FundraisingPreferenceRef] FOREIGN KEY ([MemorialTributeNotificationPreferenceCode]) REFERENCES [dbo].[FundraisingPreferenceRef] ([FundraisingPreferenceCode])
GO
ALTER TABLE [dbo].[MemorialTributeNotificationMember] ADD CONSTRAINT [FK_MemorialTributeNotificationMember_GroupMember] FOREIGN KEY ([GroupMemberKey]) REFERENCES [dbo].[GroupMember] ([GroupMemberKey])
GO
ALTER TABLE [dbo].[MemorialTributeNotificationMember] ADD CONSTRAINT [FK_MemorialTributeNotificationMember_Relationship] FOREIGN KEY ([RelationshipKey]) REFERENCES [dbo].[RelationshipMain] ([RelationshipKey])
GO